UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4Ngd8ST1KKjrDp7lMbMbTKBlrFbZO3FN/VzNqhi6M8='
WHERE
key_id = '11547f90cdaabba5ecf02737327384464958d8a32e8253871813b53344b9bcbf'
AND (
token = '/4Ngd8ST1KKjrDp7lMbMbTKBlrFbZO3FN/VzNqhi6M8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)