UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn6NsJpU7psj/2J1sm/U7QIq19eswVeqVsbcBlbU9Es='
WHERE
key_id = 'b310a25143a6f61700fa8ccfcc1499621a48a92fa515288da6582180a91b8518'
AND (
token = 'pn6NsJpU7psj/2J1sm/U7QIq19eswVeqVsbcBlbU9Es='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)