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