UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5RXh7MmA3z5RZrHP0bVqIwUa6nmaGEa4UAtU1CO95CU='
WHERE
key_id = '0983456bc4b5aabf66106f2d8ebc52543020148f11267930e78fe774cc5bfcc4'
AND (
token = '5RXh7MmA3z5RZrHP0bVqIwUa6nmaGEa4UAtU1CO95CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)