UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDRnP2azJjVudGynIHFylOz5c+5wWASnXCt7W4SfsxU='
WHERE
key_id = '28bc16db62938022f6e1b94f7e510bad95d782e1e949b7848aa2783b70c29829'
AND (
token = 'gDRnP2azJjVudGynIHFylOz5c+5wWASnXCt7W4SfsxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)