UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRuH2cOqgJRyRT7UK6Ty8JGR6/aIYhQ36nGrUQs3W6c='
WHERE
key_id = 'd9d7f4abd94e865da58d3d386505d0da59853910e59e77aaf20125bfb8cf0b75'
AND (
token = 'iRuH2cOqgJRyRT7UK6Ty8JGR6/aIYhQ36nGrUQs3W6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)