UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0THm0Ts0vLeckZa2ctiAIMhDBAZE6X3qFKJXhznmIk='
WHERE
key_id = '119dbf2a56b26280170570835b590688eececa9c620680603d8b5271bc9bf22f'
AND (
token = 'W0THm0Ts0vLeckZa2ctiAIMhDBAZE6X3qFKJXhznmIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)