UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pPBQ1qOmFvlavF21aNCxZcQH874M1HXE/pjB1GuX4Q='
WHERE
key_id = '74647f5927cf22624de079568ba2d7c139b553bdf7a7a5cccc223f905e35a61e'
AND (
token = '/pPBQ1qOmFvlavF21aNCxZcQH874M1HXE/pjB1GuX4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)