UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bDd5tsoIFjpZMgv8INgfd7dQyXyUnAa3V4sAi1jhGBk='
WHERE
key_id = 'e38ebcd2050d45cb5b3ba99536e613ce7502507b1213b92767efebc955e0875c'
AND (
token = 'bDd5tsoIFjpZMgv8INgfd7dQyXyUnAa3V4sAi1jhGBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)