UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gaHl20459b+L4Q7blCeDZMaadsnV/eyc4o5v/XXWPto='
WHERE
key_id = '3050ed20107377c9809ce767c5eb329e9e46950ca785684f53249879e4d7fe28'
AND (
token = 'gaHl20459b+L4Q7blCeDZMaadsnV/eyc4o5v/XXWPto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)