UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfZp+lyjhnb6++tpdap7yDCiaPXwRTT+wvivmdWKOug='
WHERE
key_id = 'ed50af0963753f6178f3408a89e504a26df52154f8acbbc14fb6f926a9416016'
AND (
token = 'zfZp+lyjhnb6++tpdap7yDCiaPXwRTT+wvivmdWKOug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)