UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9HvZvj6K78tMZDcj+OfTYSBW/Xj9jb0Kqo1Y4AD2uE='
WHERE
key_id = 'c59d612925994f99aeeb0e98b4b7280d6168db46bb68a3301116b5ebcfc197a5'
AND (
token = 'n9HvZvj6K78tMZDcj+OfTYSBW/Xj9jb0Kqo1Y4AD2uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)