UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2HnqDLAk0XhVU9NfsJPYnEcu36Uc2BL+VZaXQ9pjbvc='
WHERE
key_id = 'bf960187119e02913efc18aebdd464f4e3d5ed3110bb77769f18f3916856c8b9'
AND (
token = '2HnqDLAk0XhVU9NfsJPYnEcu36Uc2BL+VZaXQ9pjbvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)