UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ZB2ucnYLpEOk8BxDE658DqrVbjvpEUHlTGuZyj5+3I='
WHERE
key_id = 'bc23f112a2edf48e57e094f472d9b18f2b0486438833e2845dc89560a2e4bdc8'
AND (
token = '+ZB2ucnYLpEOk8BxDE658DqrVbjvpEUHlTGuZyj5+3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)