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