UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Z6LR4fH8m+lon8NZwZopOgNIydb+01iEqL8q5Y+VPk='
WHERE
key_id = '09e6ee543aac5c9bca9e7732f62aeed855e1ce93d021b40170fc624d06dbb795'
AND (
token = '1Z6LR4fH8m+lon8NZwZopOgNIydb+01iEqL8q5Y+VPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)