UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htw+D79A0xnMDwFXFRVXqRL95WmxYYZqTaTiAwzqPvk='
WHERE
key_id = 'fa59c4cbd752f72712d736c9a61d7bf4fbca49051cb0a10fe4635f2c0a6224bf'
AND (
token = 'htw+D79A0xnMDwFXFRVXqRL95WmxYYZqTaTiAwzqPvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)