UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9n1r3RaMoHfUrkvOL1FBHrhQYD2es4x639hwGD8uea8='
WHERE
key_id = 'abeda9240495e8c07c0e33f5cc15ec972592d5a4c50102615e78f9ed3f6ca050'
AND (
token = '9n1r3RaMoHfUrkvOL1FBHrhQYD2es4x639hwGD8uea8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)