UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GfISC6q8hTJoB1bdI2wW77Izj5xuZoKBKj0d8h3tdvU='
WHERE
key_id = 'd534076c075e7c4c5a14cae5c3c9334aed8c257c4eb6245a9512a3cacfc25cf8'
AND (
token = 'GfISC6q8hTJoB1bdI2wW77Izj5xuZoKBKj0d8h3tdvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)