UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gUAsPSM0d0r6RnKAuNq0a0/6n78leuIlvs+azYzbg8='
WHERE
key_id = '075b1224beb994f892e50a005d68357ac739d0a977119602d8c3f251f373a4ab'
AND (
token = '4gUAsPSM0d0r6RnKAuNq0a0/6n78leuIlvs+azYzbg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)