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