UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'shrfUeAFqA8HD8iVFd8xMLsbT3PJzsHoTWH0deL+fUg='
WHERE
key_id = 'd2aef06c97662d3b52dd429cf36222723448b0f4d04219469eec0da7e0992d36'
AND (
token = 'shrfUeAFqA8HD8iVFd8xMLsbT3PJzsHoTWH0deL+fUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)