UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'npXVmcGTUzHjcJgmf0ujPh6p6JRo+8X531aSUd1kL+E='
WHERE
key_id = 'ad2a2d6c8f5f8e951643e460dad4ff2ad29f04bdae25ae12167cd777756434a3'
AND (
token = 'npXVmcGTUzHjcJgmf0ujPh6p6JRo+8X531aSUd1kL+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)