UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'df2117UmHEg+zAS9C9qm4tiSnEXEYGPMSef6wa3Gxv4='
WHERE
key_id = '4e9e24d4dfd6a6a3877aa5ed2186a974627975e753d53855de22d4b90dddd27d'
AND (
token = 'df2117UmHEg+zAS9C9qm4tiSnEXEYGPMSef6wa3Gxv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)