UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1XCRXBBwSfJkaXnDStI3vnhRQqBUwfF67n2wjDkAcE='
WHERE
key_id = 'd7de4418e4ec56aa58259b86b0dcded94a1f54b882416954fe85e2cf347f4b71'
AND (
token = 'P1XCRXBBwSfJkaXnDStI3vnhRQqBUwfF67n2wjDkAcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)