UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHTgUL03angE3l07Uu/jNyKsCeGrXt1A55JXt8m7d4E='
WHERE
key_id = 'cd87c05e7e3c6a4c5b9eee8d1f6f3f07dabb3ceeb0ba6ec68d26faa34a05ed12'
AND (
token = 'gHTgUL03angE3l07Uu/jNyKsCeGrXt1A55JXt8m7d4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)