UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pVQIq+PJAlt91beqHFd+op9a0ouUxT57WqRm/nPar0='
WHERE
key_id = '0c27e39f26229367f0f5ae14f1cc6f52f6da6acf8babdc517703c3b280427ca9'
AND (
token = '+pVQIq+PJAlt91beqHFd+op9a0ouUxT57WqRm/nPar0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)