UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mNknU2urQtpdukJaGrHGtzz15H2TOEci1JwK7d6PseY='
WHERE
key_id = 'ae4feade7604fe122d02a4a849c0450d120c8cdb4e39c6a428b057413dad43ec'
AND (
token = 'mNknU2urQtpdukJaGrHGtzz15H2TOEci1JwK7d6PseY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)