UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/GBSXjDnKzLct/hgd7FeFnABXFXUPqj4E7F3ZqwvPU='
WHERE
key_id = 'd0f96b63ab0c99971743576d4564366d49f4704d03088f6e338da9c69ee9b8d8'
AND (
token = '0/GBSXjDnKzLct/hgd7FeFnABXFXUPqj4E7F3ZqwvPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)