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